    <?php
define("JL", 1);

@session_start();
// Includes obligatorios
include ('./dbconfig.php');
include ('./administration/Libraries/Tools/JLTools.class.php');

$newId = 1;
$SQL = "SELECT 
	  `int_id_administration`,
	  `txt_presentation_admin`
	FROM 
	  `tbl_administration`
	WHERE `int_id_administration` = '" . $newId . "'";

$res = mysql_query($SQL, $cnn);
$row = mysql_fetch_assoc($res);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr-FR" lang="fr-FR" >
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <meta http-equiv="pragma" content="no-cache" />
        <meta name="robots" content="index, follow" />
        <meta name="google-site-verification" content="l6Fc4-_RGKeL_0Y8H7wAhDHge8ORqjoSkWeN2WQQzrU" />
        <meta name="generator" content="LBN | Design &amp; Development Studio" />
        <title>Administration</title>
        <link href="js/lib/flexslider.css" rel="stylesheet" type="text/css" media="screen, projection" />
        <link href="base.css" rel="stylesheet" type="text/css" media="all" />
        <link href="slider/stylesheets/slider-popup.css" rel="stylesheet" type="text/css" media="screen, projection" />
        <link href="js/lib/xpopup/xpopup-1.0.css" rel="stylesheet" type="text/css" media="screen, projection" />
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
        <script>!window.jQuery && document.write(unescape('%3Cscript src="js/lib/jquery-1.7.1.min.js"%3E%3C/script%3E'))</script>
        <link rel="stylesheet" href="slider/stylesheets/coda-slider-2.0.css" type="text/css" media="screen" />
        <script type="text/javascript" src="slider/javascripts/jquery.coda-slider-2.0_update.js"></script>
        <script type="text/javascript" src="slider/javascripts/jquery.easing.1.3.js"></script>
        <script type="text/javascript" src="js/lib/xpopup/xpopup.min-1.0.js"></script>
        <script type="text/javascript" src="js/lib/jquery.xvalidator-1.0.min.js"></script>
        <script type="text/javascript" src="js/lib/jquery.cookie.min.js"></script>
        <script type="text/javascript" src="js/lib/jquery.flexslider-min.js"></script>
        <script type="text/javascript" src="js/lib/utils-1.0.min.js"></script>
        <script type="text/javascript" src="js/lib/jquery.tooltip.min.js"></script>
        <script type="text/javascript" src="administration/?act=required"></script>
        <style type="text/css">
            .block { display: inline; }
            #error_chk{ display: none;  color:#C00; }	
            label.error {font-size:15px; font-weight:bold; color:#C00; display:inline;}
            #documents{  }
            #documents td{ color:#666; font-family:Arial, Helvetica, sans-serif; }
            #documents td .views-icon{ margin-right:3px;}
            #documents td span{ font-style:none; }
            #documents td.list-fichers{ padding-left:55px; padding-top:5px; }
            #documents td ul{ list-style-type:none; }
            #documents td ul li a:hover {color: #00A893;}
            #documents td ul.icon-pdf li a{ display:block; background:url(images/16x16/pdf.png) 0px 7px  no-repeat; padding:7px 0px 5px 21px;}
            #documents td ul.icon-doc li a,#documents td ul.icon-docx li a{ display:block; background:url(images/16x16/word.png) 0px 7px  no-repeat; padding:7px 0px 5px 21px;}
            #documents td ul.icon-jpg li a{ display:block; color:#df1847; background:url(images/16x16/pictures.png) 0px 7px  no-repeat; padding:7px 0px 5px 21px;}
            #documents td ul.icon-xls li a,#documents td ul.icon-xlsx li a{ display:block; color:#df1847; background:url(images/16x16/excel.png) 0px 7px  no-repeat; padding:7px 0px 5px 21px;}
            .document-line{ border-top:dotted 1px #333; height:10px; margin-top:10px; width:500px; }

            /* Presentation */
            /*.coda-nav ul li.tab2, .coda-nav ul li.tab3{ display:none; }*/
            .coda-nav ul li a.selected{ padding-left: 30px; }
            #m-photos{ padding-left:6px; }
            .coda-nav ul li.tab2 a{ padding-left:15px; }
            .coda-nav ul li.tab2 a.current{ background-position: 20px 12px; padding-left: 15px; }
            .mphotos{background-position:20px 12px;}
            .coda-nav ul li.tab3 { display:none !important; }
            .coda-nav ul li#lim-acess { display:none; }

            .coda-nav ul li a.submenu{ padding-left: 15px; background-position:20px -10px;  }
            .coda-nav ul li a.submenu.current{ padding-left: 15px; background-position:20px 12px;  }

        </style>
        <!--[if IE]>
        <style>.submitimagehidden{ margin-left:160px; margin-top:43px; }</style>
        <![endif]-->
        <!--[if IE 7]>
        <link href="base-ie7.css" rel="stylesheet" type="text/css" media="screen, projection" charset="utf-8" />
        <![endif]-->
        <link rel="shortcut icon" href="favicon.ico" />
        <link rel="alternate" type="application/rss+xml" title="CSME Actualitès - RSS Feed" href="http://feeds.feedburner.com/csme-actualites" />
    </head>
    <body>
        
        <?php include 'modules/annonce.html.php'; ?>

        <div id="button_top">
            <a href="javascript:;"><img src="images/arrow_top.png" width="18" height="25" />
                <span id="top">TOP <br /><strong>SITE</strong></span></a>
        </div>

        <div id="main-container">

            <!-- BN-TOP -->
            <div id="bn-top" class="bxshd">    

                <!-- MENU-TOP -->
                <div class="menu-top">

                    <div id="logo">
                        <a href="./" title="CSME Club Sportif Multisections d'Epinay-sur-Seine"><img alt="CSME LOGO" src="images/csme-logo.png" width="174" height="159" /></a>
                    </div>
                    
                    <!-- NEWSLETTER -->
                    <div id="newsletter" class="bxshd">
                        <div class="newscenter">
                            <div class="newscontent">
                                <h3><img src="images/sobre.png" width="16" height="12" /> Newsletter</h3>
                                <div class="subtitle">Inscrivez-vous à notre newsletter.</div>
                                <div><form action="./" method="post" enctype="application/x-www-form-urlencoded" name="frmnewsletter" id="frmnewsletter">
                                        <input name="txtnom" type="text" class="txtnewsletter" id="txtnom" autocomplete="off" />
                                        <label id="email">
                                            <input name="txtemail" type="text" class="txtnewsletter" id="txtemail" autocomplete="off" />
                                            <input class="valid" type="submit" value="OK" onfocus="this.blur();" />
                                        </label>
                                    </form>
                                </div>


                                <div id="partenaires">

                                    <div class="face_fb_plugin"><a title="Suivez-nous sur facebook" target="_blank" href="http://www.facebook.com/CSMEpinaysurSeine"></a></div>
                                    <div class="text_fb_plugin">Soyez le premier parmi vos amis.
                                        <br />Rejoignez-nous vite !
                                    </div>
                                    <div class="fb_like_plugin">
                                        <iframe src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.facebook.com%2Fpages%2FCSME-Club-Sportif-Multisections-dEpinay-sur-Seine%2F176399182395742&amp;layout=button_count&amp;locale=fr_FR&amp;show_faces=false&amp;width=170&amp;action=like&amp;colorscheme=light&amp;height=21" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:170px; height:21px;" allowTransparency="true"></iframe>
                                    </div>

                                </div>
                            </div>
                        </div>
                    </div>
                    <!-- END NEWSLETTER -->



                    <!-- MENU -->
                    <ul>
                        <li><a class="link" title="Accueil" href="./"  target="_parent">Accueil</a></li>
                        <li><a class="link" title="Présentation" href="presentation.html"  target="_parent">Présentation</a></li>
                        <li><a class="link" title="Les sections" target="_parent" id="les_sections_id">Les sections</a>

                            <?php
                            include_once 'modules/menu.html.php';
                            printMenu($select);
                            ?>
                        </li>
                        <li><a class="link" title="Actualités" href="actualites.html" target="_parent">Actu. CSME</a></li>
                        <li><a class="link selected" title="Administration" href="administration.html" target="_parent">Administration</a></li>
                        <li><a class="link" title="Contact" href="contacts.html" target="_parent">Contact</a></li>
                    </ul>
                    <!-- END MENU-->


                </div>
                <!-- END MENU-TOP -->


            </div>
            <!-- END BN-TOP -->


            <!-- BN-CONTENT-->
            <div id="bn-content">

                <!-- BN CONTENT TEXT -->
                <div class="bn-content-text bxshd">
                    <div class="bn-ct-top"></div>
                    <table border="0" cellpadding="0" cellspacing="0" class="bn-ct-repeat">
                        <tr>
                            <td class="bn-ct-r-center">
                                <div id="admin-nav" class="bn-ct-r-center-menu">
                                    <div class="bn-menu-title">
                                        <div class="bn-menu-icon"></div>
                                        <h1 title="Administration">Administration</h1>
                                    </div>
                                </div>

                                <div class="coda-slider preload" id="coda-slider-1">

                                    <div class="panel">
                                        <div class="panel-wrapper">
                                            <?php
                                            $_val = trim($row['txt_presentation_admin']);
                                            if (empty($_val) || $_val == "&nbsp;")
                                                $bloq = "true";
                                            ?>
                                            <h2 class="title" lang="<?php echo $bloq; ?>" id="m-presentation">Présentation<div class="sub-line title"></div></h2>
                                            <p class="section">
                                                <?php echo $row['txt_presentation_admin']; ?>
                                            </p>
                                        </div>
                                    </div>

                                    <div class="panel">
                                        <div class="panel-wrapper">
                                            <?php
                                            $SQL = "SELECT 
                                  `int_id_membres_admin`,
                                  `var_photo`,
                                  `txt_photo_html`,
                                  `var_noms`,
                                  `var_status`,
                                  `var_dates`,
                                  `int_mem_order`,
                                  `int_id_administration`,
                                  `int_id_state`
                                FROM 
                                  `tbl_membres_admin`
                                WHERE `int_id_administration` = '" . $newId . "' 
                                ORDER BY int_id_administration ASC ";

                                            $res2 = mysql_query($SQL, $cnn);

                                            if (mysql_num_rows($res2) <= 0)
                                                $bloq = "true";
                                            ?>
                                            <h2 class="title" dir="<?php echo $bloq; ?>" id="m-membresdubureau">Membres de bureau<div class="sub-line title"></div></h2>
                                            <p>

                                                <?php
                                                while ($row3 = mysql_fetch_assoc($res2)) {
                                                    ?>
                                                    <table align="left" class="membre-panel" border="0" cellpadding="0" cellspacing="0">
                                                        <tr>
                                                            <td align="right" valign="bottom" class="m-imagen">
                                                                <img width="130" src="./images/membres/<?php echo $row3['var_photo']; ?>" />
                                                            </td>
                                                            <td class="m-texto" align="left" valign="bottom">

                                                                <strong style="font-weight:bold;"><?php echo $row3['var_noms']; ?></strong><br />

                                                                <em style="font-style:italic;"><?php echo $row3['var_status']; ?><br />

                                                                    <?php echo $row3['var_dates']; ?></em>

                                                            </td>
                                                        </tr>
                                                    </table>

                                                <?php } ?>

                                            </p>
                                        </div>
                                    </div>

                                    <div class="panel">
                                        <div class="panel-wrapper">
                                            <h2 class="title" id="m-adhesion"><div class="sub-line title"></div></h2>
                                        </div>
                                    </div>

                                    <div class="panel">
                                        <div class="panel-wrapper">
                                            <?php
                                            $SQL = "SELECT 
                                            `int_id_gallery`,
                                            `var_title_gallery`,
                                            `int_num_photos`,
                                            `var_path_gallery`,
                                            `int_id_sections_view`
                                            FROM 
                                            `tbl_gallery`
                                            WHERE `int_id_sections_view` = '1' AND `int_id_state` <> 3 AND `bol_admin` = 1 AND `int_num_photos` > 0
                                            ORDER BY `int_id_gallery` DESC";
                                            $res7 = mysql_query($SQL, $cnn);
                                            if (mysql_num_rows($res7) <= 0)
                                                $bloq = "true";
                                            ?>
                                            <h2 class="title" dir="<?php echo $bloq; ?>" id="m-photos">Photos</h2>
                                        </div>
                                    </div>


                                    <?php
                                    while ($row7 = mysql_fetch_assoc($res7)):
                                        ?>
                                        <div class="panel">
                                            <div class="panel-wrapper">
                                                <h2 class="title" id="album-<?php echo $row7['int_id_gallery']; ?>"><?php echo $row7['var_title_gallery']; ?><div class="sub-line title"></div></h2>
                                                <iframe src="galerie.php?id=<?php echo $row7['int_id_gallery']; ?>&path=<?php echo $row7['var_path_gallery']; ?>" frameborder="0" scrolling="no" allowtransparency="true" style="width:705px; height:515px;"></iframe>
                                            </div>
                                        </div>
                                        <?php
//                                        $_i++;
                                    endwhile;
                                    ?>


                                    <div class="panel">
                                        <div class="panel-wrapper">
                                            <?php
                                            $SQL = "SELECT 
                                                `int_id_lien_admin`,
                                                `var_lien_title`,
                                                `var_lin_link`,
                                                `var_file_single`,
                                                `var_file_img`,
                                                `var_extension`,
                                                `int_id_administration`,
                                                `int_id_state`
                                                FROM 
                                                `tbl_liens_admin` 
                                                GROUP BY var_extension
                                                ORDER BY `var_file_img` ASC ";

                                            $result = mysql_query($SQL, $cnn);

                                            if (mysql_num_rows($result) <= 0)
                                                $bloq = "true";
                                            ?>
                                            <h2 class="title" dir="<?php echo $bloq; ?>" id="m-actualites">Documents officiels<div class="sub-line title"></div></h2>
                                            <p>
                                                <?php
                                                if (mysql_num_rows($result) > 0) {
                                                    $jl = JLTools::getInstance();
                                                    while ($row = mysql_fetch_assoc($result)) {
                                                        $SQL = "SELECT 
                                                            `int_id_lien_admin`,
                                                            `var_lien_title`,
                                                            `var_lin_link`,
                                                            `var_file_single`,
                                                            `var_file_img`,
                                                            `int_id_administration`,
                                                            `int_id_state`
                                                        FROM 
                                                            `tbl_liens_admin`
                                                        WHERE var_extension = '" . $row['var_extension'] . "'
                                                        ORDER BY `int_id_lien_admin` DESC ";

                                                        $res = mysql_query($SQL, $cnn);
                                                        ?>
                                                        <table id="documents" width="100%" border="0" cellpadding="0" cellspacing="0" style="">
                                                            <tr>
                                                                <td valign="bottom" style="padding-top:15px;">

                                                                    <?php
                                                                    $icon = $jl->getFileExtension($row['var_lin_link']);
                                                                    switch ($icon) {
                                                                        case "jpg":
                                                                            $img = "pictures.png";
                                                                            $imgtitle = " Image";
                                                                            break;

                                                                        case "pdf":
                                                                            $img = "pdf.png";
                                                                            $imgtitle = " PDF";
                                                                            break;

                                                                        case "doc";
                                                                        case "docx";
                                                                            $img = "word.png";
                                                                            $imgtitle = " Word";
                                                                            break;

                                                                        case "xls";
                                                                        case "xlsx";
                                                                            $img = "excel.png";
                                                                            $imgtitle = " Excel";
                                                                            break;
                                                                    }
                                                                    ?>

                                                                    <img class="views-icon" src="./images/32x32/<?php echo $img; ?>" width="32" height="32" /> <span>Fichier <?php echo $imgtitle; ?></span>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="list-fichers">

                                                                    <ul class="icon-<?php echo $icon; ?>">
                                                                        <?php
                                                                        while ($row2 = mysql_fetch_assoc($res)) {
                                                                            ?>
                                                                            <li><a href="<?php echo $row2['var_lin_link']; ?>" target="_blank"><?php echo $row2['var_lien_title']; ?></a></li>
                                                                        <?php } ?>
                                                                    </ul>
                                                                </td>
                                                            </tr>
                                                        </table>
                                                        <?php
                                                    }
                                                }
                                                ?>
                                            </p>
                                        </div>
                                    </div>
                                </div>          
                            </td>
                        </tr>
                    </table>
                    <div class="fldbtm"></div>                    
                </div>
                <!-- END CONTENT TEXT -->


                <div id="push"></div>

            </div>
            <!-- BN-CONTENT-->

        </div>


        <?php
        include 'modules/footer.html.php';
        printFooter($cnn, $select);
        printTooltips($cnn);
        ?>

        <script type="text/javascript" src="js/js-main.js"></script>
        <script type="text/javascript" src="js/slider-les-sections2.js"></script>

        <?php
        printMyVisites();
        @mysql_close();
        ?>
    </body>
</html>